Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
RetailStoreID (FK)(PK) | A unique retailer assigned identifier for an RetailStore, DistributionCenter or AdministrationCenter | ID_STR_RTL | Identity | integer | SalesMeter(AS_MTR_SLS) |
SalesMeterID (FK)(PK) | A system-assigned unique identifier for a sales meter. | ID_MTR_SLS | Identity | integer | SalesMeter(AS_MTR_SLS) |
ReadingNumber (PK) | A sequential number uniquely identifying this particular reading within the context of the SaleMeter being used. | AI_RDG | LineNumber | smallint | |
MeterReadingQuantity | The Meter Reading value. | QY_RDG | Quantity | decimal(9,2) | |
TimeStamp | The date & time the meter reading was taken | TS_RDG | AuditDateTime | datetime | |
ReasonCode | A 2 character code denoting the reason the meter reading was taken | RC_RDG | Code | varchar(20) | |
TransactionID (FK) | A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. | ID_TRN | IdentityUUID | char(32) | ForecourtSettlementTransaction(TR_STLM_FCRT) |